The following table lists the Field data types.
DAO Field data type | Constant |
---|---|
Big Integer | DbBigInt |
Binary | DbBinary |
Boolean | DbBoolean |
Byte | DbByte |
Char | DbChar |
Currency | DbCurrency |
Date/Time | DbDate |
Decimal | DbDecimal |
Double | DbDouble |
Float | DbFloat |
GUID | DbGUID |
Integer | DbInteger |
Long | DbLong |
Long Binary (OLE Object) | DbLongBinary |
Memo | DbMemo |
Numeric | DbNumeric |
Single | DbSingle |
Text | DbText |
Time | DbTime |
TimeStamp | DbTimeStamp |
VarBinary | DbVarBinary |